package com.gugu.procedure;


import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import springfox.documentation.swagger2.annotations.EnableSwagger2;

@SpringBootApplication
@EnableSwagger2
public class ProcedureApp {

//    用工优化  先将结果存临时表
//    select  *  from  (select order_no,specs,staff_id,production,count(1) amount ,'0' status
//    from   production_record
//    where end_time is  null   and  status in('1','0') and order_no='2023031073'
//    GROUP BY order_no,specs,staff_id ,production
//            UNION
//    select order_no,specs,staff_id,production,count(1) amount ,'1' status
//    from   production_record
//    where end_time is not   null  and  status in('1','0')  and order_no='2023031073'
//    GROUP BY order_no,specs,staff_id ,production)  a where 1=1


    //  新品订单的下一个工序 open/nextProductionRecord

    public static void main(String[] args) {
        SpringApplication.run(ProcedureApp.class, args);

    }


}
